CREATE TABLE [dbo].[Producer]
(
[ContactID] [numeric] (18, 0) NOT NULL,
[SimpleIntermediateAdvancedInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_SimpleIntermediateAdvancedInd] DEFAULT ('S'),
[AlwaysModifyFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_AlwaysModifyFlag] DEFAULT ('Y'),
[DefaultOwnerMeGroupSpecificInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_DefaultOwnerMeGroupSpecificInd] DEFAULT ('M'),
[DefaultOwnerContactID] [numeric] (18, 0) NULL,
[WYSIWYGTextboxInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_WYSIWYGTextboxInd] DEFAULT ('W'),
[DefaultReminderDays] [int] NULL,
[NavEditEditorPropertiesInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_NavEditEditorPropertiesInd] DEFAULT ('P'),
[NavNewEditorPropertiesInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_NavNewEditorPropertiesInd] DEFAULT ('P'),
[ContentEditEditorPropertiesInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_ContentEditEditorPropertiesInd] DEFAULT ('P'),
[ContentNewEditorPropertiesInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_ContentNewEditorPropertiesInd] DEFAULT ('P'),
[WarnMissingTagFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_WarnMissingTagFlag] DEFAULT ('Y'),
[ShowPublishOptionWindowFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_ShowPublishOptionWindowFlag] DEFAULT ('N'),
[PublishDescendantsFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_PublishDescendantsFlag] DEFAULT ('Y'),
[DefaultWebsiteKey] [uniqueidentifier] NULL,
[ShowProgressWindowFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Producer_ShowProgressWindowFlag] DEFAULT ('Y')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Producer] ADD CONSTRAINT [PK_Producer] PRIMARY KEY CLUSTERED ([ContactID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Producer] TO [IMIS]
GRANT SELECT ON  [dbo].[Producer] TO [IMIS]
GRANT INSERT ON  [dbo].[Producer] TO [IMIS]
GRANT DELETE ON  [dbo].[Producer] TO [IMIS]
GRANT UPDATE ON  [dbo].[Producer] TO [IMIS]
GO